package com.mpyy.dao.everyday;

import com.mpyy.pojo.PurchaseStock;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @version 1.0
 * @Description PurchaseDaoInter
 * Author yyjc
 * @Date 2022-03-09 10:25
 */
@Mapper
@Repository
public interface PurchaseDaoInter {
    /**
     * 根据条件查询供货商信息
     * @param supid
     * @return
     */
    @Select("SELECT purStoId,depotName,purStoPayable,purStoOutof,empName FROM supplier_info a,purchase_stock b,employee_info c,depot_info d WHERE" +
            " b.empId=c.empId AND b.depotId=d.depotId AND a.supId=b.supid AND CONCAT(a.supId,a.supName) LIKE CONCAT('%',#{supid},'%') ")
    public List<PurchaseStock> purchaseall(String supid);
}
